Tabela SeriesData

Definicja tabeli SeriesData

Name

SeriesData

Code

SeriesData

Comment

 


Lista kolumn tabeli SeriesData

Name

Code

SeriesDataID

SeriesDataID

ProductionDate

ProductionDate

ValidityDate

ValidityDate

SeriesNo

SeriesNo

Blocked

Blocked

BlockDT

BlockDT

Comments

Comments


Kolumna SeriesDataID tabeli SeriesData

Definicja kolumny SeriesDataID tabeli SeriesData

Name

SeriesDataID

Code

SeriesDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ProductionDate tabeli SeriesData

Definicja kolumny ProductionDate tabeli SeriesData

Name

ProductionDate

Code

ProductionDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ValidityDate tabeli SeriesData

Definicja kolumny ValidityDate tabeli SeriesData

Name

ValidityDate

Code

ValidityDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SeriesNo tabeli SeriesData

Definicja kolumny SeriesNo tabeli SeriesData

Name

SeriesNo

Code

SeriesNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Blocked tabeli SeriesData

Definicja kolumny Blocked tabeli SeriesData

Name

Blocked

Code

Blocked

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BlockDT tabeli SeriesData

Definicja kolumny BlockDT tabeli SeriesData

Name

BlockDT

Code

BlockDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli SeriesData

Definicja kolumny Comments tabeli SeriesData

Name

Comments

Code

Comments

Data Type

CLOB

Mandatory

No

Comment

 


Lista kluczy tabeli SeriesData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SeriesData

Definicja klucza Identifier_1 tabeli SeriesData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment